BOOKING analitical preview

Dataset statistics

Number of variables	18
Number of observations	515431
Missing cells	6536
Missing cells (%)	0.1%
Duplicate rows	29
Duplicate rows (%)	< 0.1%
Total size in memory	70.8 MiB
Average record size in memory	144.0 B

Variable types

Text	7
Numeric	9
DateTime	1
Categorical	1

Alerts

Dataset has 29 (< 0.1%) duplicate rows	Duplicates
`additional_number_of_scoring` is highly overall correlated with `total_number_of_reviews`	High correlation
`total_number_of_reviews` is highly overall correlated with `additional_number_of_scoring`	High correlation
`reviewer_score` is highly overall correlated with `sample`	High correlation
`sample` is highly overall correlated with `reviewer_score`	High correlation
`review_total_negative_word_counts` has 127816 (24.8%) zeros	Zeros
`review_total_positive_word_counts` has 35924 (7.0%) zeros	Zeros
`reviewer_score` has 128935 (25.0%) zeros	Zeros

Reproduction

Analysis started	2023-11-09 18:28:23.590288
Analysis finished	2023-11-09 18:29:21.804067
Duration	58.21 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

hotel_address
Text

Distinct	1493
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	3.9 MiB

Length

Max length	96
Median length	78
Mean length	59.880743
Min length	34

Characters and Unicode

Total characters	30864391
Distinct characters	63
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Via Senigallia 6 20161 Milan Italy
2nd row	Arlandaweg 10 Westpoort 1043 EW Amsterdam Netherlands
3rd row	Mallorca 251 Eixample 08008 Barcelona Spain
4th row	Piazza Della Repubblica 17 Central Station 20124 Milan Italy
5th row	Singel 303 309 Amsterdam City Center 1012 WJ Amsterdam Netherlands

Value	Count	Frequency (%)
london	283656	5.7%
kingdom	262691	5.3%
united	262300	5.2%
westminster	95105	1.9%
borough	90619	1.8%
amsterdam	82632	1.7%
city	62594	1.3%
barcelona	61231	1.2%
street	60433	1.2%
spain	60149	1.2%
Other values (2525)	3681626	73.6%

Most occurring characters

Value	Count	Frequency (%)
	4488010	14.5%
n	2380505	7.7%
e	2223708	7.2%
a	1874958	6.1%
o	1633164	5.3%
t	1599765	5.2%
r	1480166	4.8%
i	1459005	4.7%
d	1357818	4.4%
s	939373	3.0%
Other values (53)	11427919	37.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	19001876	61.6%
Space Separator	4488010	14.5%
Uppercase Letter	4383600	14.2%
Decimal Number	2990905	9.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	2380505	12.5%
e	2223708	11.7%
a	1874958	9.9%
o	1633164	8.6%
t	1599765	8.4%
r	1480166	7.8%
i	1459005	7.7%
d	1357818	7.1%
s	939373	4.9%
m	741137	3.9%
Other values (16)	3312277	17.4%

Uppercase Letter

Value	Count	Frequency (%)
L	401274	9.2%
S	398881	9.1%
W	363630	8.3%
C	343437	7.8%
K	340269	7.8%
U	295947	6.8%
B	283345	6.5%
A	243318	5.6%
P	202834	4.6%
E	167216	3.8%
Other values (16)	1343449	30.6%

Decimal Number

Value	Count	Frequency (%)
1	725572	24.3%
0	587741	19.7%
2	361242	12.1%
5	236677	7.9%
7	223113	7.5%
3	211488	7.1%
8	202229	6.8%
4	180522	6.0%
6	144235	4.8%
9	118086	3.9%

Space Separator

Value	Count	Frequency (%)
	4488010	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	23385476	75.8%
Common	7478915	24.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	2380505	10.2%
e	2223708	9.5%
a	1874958	8.0%
o	1633164	7.0%
t	1599765	6.8%
r	1480166	6.3%
i	1459005	6.2%
d	1357818	5.8%
s	939373	4.0%
m	741137	3.2%
Other values (42)	7695877	32.9%

Common

Value	Count	Frequency (%)
	4488010	60.0%
1	725572	9.7%
0	587741	7.9%
2	361242	4.8%
5	236677	3.2%
7	223113	3.0%
3	211488	2.8%
8	202229	2.7%
4	180522	2.4%
6	144235	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	30864391	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	4488010	14.5%
n	2380505	7.7%
e	2223708	7.2%
a	1874958	6.1%
o	1633164	5.3%
t	1599765	5.2%
r	1480166	4.8%
i	1459005	4.7%
d	1357818	4.4%
s	939373	3.0%
Other values (53)	11427919	37.0%

additional_number_of_scoring
Real number (ℝ)

HIGH CORRELATION

Distinct	480
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	498.27508

Minimum	1
Maximum	2682
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.9 MiB

Quantile statistics

Minimum	1
5-th percentile	58
Q1	169
median	342
Q3	660
95-th percentile	1444
Maximum	2682
Range	2681
Interquartile range (IQR)	491

Descriptive statistics

Standard deviation	500.61896
Coefficient of variation (CV)	1.004704
Kurtosis	5.747933
Mean	498.27508
Median Absolute Deviation (MAD)	202
Skewness	2.2070482
Sum	2.5682642 × 10⁸
Variance	250619.34
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2682	4789	0.9%
2288	4256	0.8%
2623	4169	0.8%
1831	3578	0.7%
1936	3212	0.6%
256	3079	0.6%
1274	2958	0.6%
832	2934	0.6%
211	2858	0.6%
404	2836	0.6%
Other values (470)	480762	93.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	13	< 0.1%
4	12	< 0.1%
5	39	< 0.1%
6	118	< 0.1%
7	56	< 0.1%
8	57	< 0.1%
9	89	< 0.1%
10	195	< 0.1%
11	143	< 0.1%
12	67	< 0.1%

Value	Count	Frequency (%)
2682	4789	0.9%
2623	4169	0.8%
2288	4256	0.8%
1936	3212	0.6%
1831	3578	0.7%
1485	2628	0.5%
1471	2155	0.4%
1444	2565	0.5%
1427	2227	0.4%
1322	2223	0.4%

review_date
Date

Distinct	731
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.9 MiB

Minimum	2015-08-04 00:00:00
Maximum	2017-08-03 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

average_score
Real number (ℝ)

Distinct	34
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.3976296

Minimum	5.2
Maximum	9.8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.9 MiB

Quantile statistics

Minimum	5.2
5-th percentile	7.4
Q1	8.1
median	8.4
Q3	8.8
95-th percentile	9.2
Maximum	9.8
Range	4.6
Interquartile range (IQR)	0.7

Descriptive statistics

Standard deviation	0.54803327
Coefficient of variation (CV)	0.065260472
Kurtosis	0.4237615
Mean	8.3976296
Median Absolute Deviation (MAD)	0.3
Skewness	-0.54586802
Sum	4328398.6
Variance	0.30034046
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=34)

Value	Count	Frequency (%)
8.4	41222	8.0%
8.1	38120	7.4%
8.5	38066	7.4%
8.7	37798	7.3%
8.6	36945	7.2%
8.2	34847	6.8%
8.3	32880	6.4%
8.8	30836	6.0%
8.9	28487	5.5%
8	22341	4.3%
Other values (24)	173889	33.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5.2	65	< 0.1%
6.4	1163	0.2%
6.6	400	0.1%
6.7	965	0.2%
6.8	1327	0.3%
6.9	1737	0.3%
7	3899	0.8%
7.1	6780	1.3%
7.2	684	0.1%
7.3	3997	0.8%

Value	Count	Frequency (%)
9.8	28	< 0.1%
9.6	915	0.2%
9.5	1207	0.2%
9.4	9339	1.8%
9.3	12659	2.5%
9.2	12935	2.5%
9.1	21379	4.1%
9	21001	4.1%
8.9	28487	5.5%
8.8	30836	6.0%

hotel_name
Text

Distinct	1492
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	3.9 MiB

Length

Max length	60
Median length	43
Mean length	25.308113
Min length	2

Characters and Unicode

Total characters	13044586
Distinct characters	63
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Hotel Da Vinci
2nd row	Urban Lodge Hotel
3rd row	Alexandra Barcelona A DoubleTree by Hilton
4th row	Hotel Principe Di Savoia
5th row	Hotel Esther a

Value	Count	Frequency (%)
hotel	234949	11.6%
london	137227	6.8%
the	58688	2.9%
park	43928	2.2%
amsterdam	39866	2.0%
hilton	35490	1.8%
by	26928	1.3%
plaza	23104	1.1%
paris	21791	1.1%
grand	18430	0.9%
Other values (1595)	1385484	68.4%

Most occurring characters

Value	Count	Frequency (%)
	1512309	11.6%
e	1228451	9.4%
o	1084419	8.3%
n	970216	7.4%
a	903501	6.9%
t	815894	6.3%
l	767890	5.9%
r	726361	5.6%
i	570486	4.4%
s	434786	3.3%
Other values (53)	4030273	30.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	9510919	72.9%
Uppercase Letter	1986425	15.2%
Space Separator	1512309	11.6%
Decimal Number	34933	0.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1228451	12.9%
o	1084419	11.4%
n	970216	10.2%
a	903501	9.5%
t	815894	8.6%
l	767890	8.1%
r	726361	7.6%
i	570486	6.0%
s	434786	4.6%
d	417172	4.4%
Other values (16)	1591743	16.7%

Uppercase Letter

Value	Count	Frequency (%)
H	366316	18.4%
L	178460	9.0%
P	162962	8.2%
C	138637	7.0%
T	128310	6.5%
A	122329	6.2%
S	117547	5.9%
M	112334	5.7%
B	109084	5.5%
G	77517	3.9%
Other values (16)	472929	23.8%

Decimal Number

Value	Count	Frequency (%)
4	7293	20.9%
1	6887	19.7%
2	5391	15.4%
0	4773	13.7%
8	4021	11.5%
5	1905	5.5%
7	1413	4.0%
9	1276	3.7%
6	1154	3.3%
3	820	2.3%

Space Separator

Value	Count	Frequency (%)
	1512309	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	11497344	88.1%
Common	1547242	11.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1228451	10.7%
o	1084419	9.4%
n	970216	8.4%
a	903501	7.9%
t	815894	7.1%
l	767890	6.7%
r	726361	6.3%
i	570486	5.0%
s	434786	3.8%
d	417172	3.6%
Other values (42)	3578168	31.1%

Common

Value	Count	Frequency (%)
	1512309	97.7%
4	7293	0.5%
1	6887	0.4%
2	5391	0.3%
0	4773	0.3%
8	4021	0.3%
5	1905	0.1%
7	1413	0.1%
9	1276	0.1%
6	1154	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	13044586	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1512309	11.6%
e	1228451	9.4%
o	1084419	8.3%
n	970216	7.4%
a	903501	6.9%
t	815894	6.3%
l	767890	5.9%
r	726361	5.6%
i	570486	4.4%
s	434786	3.3%
Other values (53)	4030273	30.9%

reviewer_nationality
Text

Distinct	227
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.9 MiB

Length

Max length	38
Median length	34
Mean length	14.036255
Min length	1

Characters and Unicode

Total characters	7234721
Distinct characters	52
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9 ?
Unique (%)	< 0.1%

Sample

1st row	United Kingdom
2nd row	Belgium
3rd row	Sweden
4th row	United States of America
5th row	United Kingdom

Value	Count	Frequency (%)
united	290859	31.9%
kingdom	245165	26.9%
of	35804	3.9%
states	35464	3.9%
america	35390	3.9%
australia	21663	2.4%
ireland	14820	1.6%
arab	10230	1.1%
emirates	10230	1.1%
saudi	8945	1.0%
Other values (262)	203752	22.3%

Most occurring characters

Value	Count	Frequency (%)
	1427753	19.7%
i	707320	9.8%
n	664281	9.2%
d	607023	8.4%
e	500464	6.9%
t	445275	6.2%
a	370487	5.1%
o	323560	4.5%
m	315098	4.4%
U	292136	4.0%
Other values (42)	1581324	21.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4930916	68.2%
Space Separator	1427753	19.7%
Uppercase Letter	876052	12.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	707320	14.3%
n	664281	13.5%
d	607023	12.3%
e	500464	10.1%
t	445275	9.0%
a	370487	7.5%
o	323560	6.6%
m	315098	6.4%
g	272651	5.5%
r	191548	3.9%
Other values (16)	533209	10.8%

Uppercase Letter

Value	Count	Frequency (%)
U	292136	33.3%
K	254825	29.1%
A	84112	9.6%
S	72530	8.3%
I	35439	4.0%
C	17243	2.0%
N	15489	1.8%
E	13498	1.5%
G	12967	1.5%
B	11800	1.3%
Other values (15)	66013	7.5%

Space Separator

Value	Count	Frequency (%)
	1427753	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5806968	80.3%
Common	1427753	19.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	707320	12.2%
n	664281	11.4%
d	607023	10.5%
e	500464	8.6%
t	445275	7.7%
a	370487	6.4%
o	323560	5.6%
m	315098	5.4%
U	292136	5.0%
g	272651	4.7%
Other values (41)	1308673	22.5%

Common

Value	Count	Frequency (%)
	1427753	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7234721	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1427753	19.7%
i	707320	9.8%
n	664281	9.2%
d	607023	8.4%
e	500464	6.9%
t	445275	6.2%
a	370487	5.1%
o	323560	4.5%
m	315098	4.4%
U	292136	4.0%
Other values (42)	1581324	21.9%

negative_review
Text

Distinct	330011
Distinct (%)	64.0%
Missing	0
Missing (%)	0.0%
Memory size	3.9 MiB

Length

Max length	1966
Median length	1910
Mean length	93.799847
Min length	1

Characters and Unicode

Total characters	48347349
Distinct characters	63
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	323747 ?
Unique (%)	62.8%

Sample

1st row	Would have appreciated a shop in the hotel that sold drinking water etc but not necessity Would recommend if like us you arrive late at night to bring drinks from plane airport as there s no shop nearby There is a minibar though if you want to pay those prices
2nd row	No tissue paper box was present at the room
3rd row	Pillows
4th row	No Negative
5th row	No Negative

Value	Count	Frequency (%)
the	531014	5.8%
was	236629	2.6%
a	230131	2.5%
to	228748	2.5%
and	219362	2.4%
no	197739	2.1%
room	175898	1.9%
in	167932	1.8%
negative	129371	1.4%
not	125608	1.4%
Other values (55627)	6957269	75.6%

Most occurring characters

Value	Count	Frequency (%)
	9296160	19.2%
e	4707415	9.7%
t	3566208	7.4%
o	3561163	7.4%
a	3075708	6.4%
i	2440915	5.0%
n	2398199	5.0%
r	2320280	4.8%
s	2084557	4.3%
h	1783020	3.7%
Other values (53)	13113724	27.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	37604485	77.8%
Space Separator	9296160	19.2%
Uppercase Letter	1249538	2.6%
Decimal Number	197166	0.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	4707415	12.5%
t	3566208	9.5%
o	3561163	9.5%
a	3075708	8.2%
i	2440915	6.5%
n	2398199	6.4%
r	2320280	6.2%
s	2084557	5.5%
h	1783020	4.7%
l	1573945	4.2%
Other values (16)	10093075	26.8%

Uppercase Letter

Value	Count	Frequency (%)
N	345285	27.6%
T	173927	13.9%
I	152902	12.2%
W	60039	4.8%
A	58045	4.6%
S	54561	4.4%
B	53980	4.3%
R	46249	3.7%
O	34350	2.7%
E	33480	2.7%
Other values (16)	236720	18.9%

Decimal Number

Value	Count	Frequency (%)
0	40979	20.8%
1	35807	18.2%
2	32771	16.6%
5	22588	11.5%
3	21838	11.1%
4	18870	9.6%
6	6931	3.5%
8	6116	3.1%
7	6066	3.1%
9	5200	2.6%

Space Separator

Value	Count	Frequency (%)
	9296160	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	38854023	80.4%
Common	9493326	19.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	4707415	12.1%
t	3566208	9.2%
o	3561163	9.2%
a	3075708	7.9%
i	2440915	6.3%
n	2398199	6.2%
r	2320280	6.0%
s	2084557	5.4%
h	1783020	4.6%
l	1573945	4.1%
Other values (42)	11342613	29.2%

Common

Value	Count	Frequency (%)
	9296160	97.9%
0	40979	0.4%
1	35807	0.4%
2	32771	0.3%
5	22588	0.2%
3	21838	0.2%
4	18870	0.2%
6	6931	0.1%
8	6116	0.1%
7	6066	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	48347349	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	9296160	19.2%
e	4707415	9.7%
t	3566208	7.4%
o	3561163	7.4%
a	3075708	6.4%
i	2440915	5.0%
n	2398199	5.0%
r	2320280	4.8%
s	2084557	4.3%
h	1783020	3.7%
Other values (53)	13113724	27.1%

review_total_negative_word_counts
Real number (ℝ)

ZEROS

Distinct	402
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.53976

Minimum	0
Maximum	408
Zeros	127816
Zeros (%)	24.8%
Negative	0
Negative (%)	0.0%
Memory size	3.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	9
Q3	23
95-th percentile	69
Maximum	408
Range	408
Interquartile range (IQR)	21

Descriptive statistics

Standard deviation	29.690973
Coefficient of variation (CV)	1.6014756
Kurtosis	31.420396
Mean	18.53976
Median Absolute Deviation (MAD)	9
Skewness	4.4082792
Sum	9555967
Variance	881.55389
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	127816	24.8%
2	24639	4.8%
3	18134	3.5%
6	17735	3.4%
5	16794	3.3%
7	16128	3.1%
4	15054	2.9%
8	14711	2.9%
9	13632	2.6%
10	12414	2.4%
Other values (392)	238374	46.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	127816	24.8%
2	24639	4.8%
3	18134	3.5%
4	15054	2.9%
5	16794	3.3%
6	17735	3.4%
7	16128	3.1%
8	14711	2.9%
9	13632	2.6%
10	12414	2.4%

Value	Count	Frequency (%)
408	1	< 0.1%
403	2	< 0.1%
402	2	< 0.1%
401	1	< 0.1%
400	1	< 0.1%
399	2	< 0.1%
398	1	< 0.1%
397	1	< 0.1%
395	1	< 0.1%
393	2	< 0.1%

total_number_of_reviews
Real number (ℝ)

HIGH CORRELATION

Distinct	1142
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2744.2591

Minimum	43
Maximum	16670
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.9 MiB

Quantile statistics

Minimum	43
5-th percentile	437
Q1	1161
median	2134
Q3	3633
95-th percentile	7371
Maximum	16670
Range	16627
Interquartile range (IQR)	2472

Descriptive statistics

Standard deviation	2317.8237
Coefficient of variation (CV)	0.8446082
Kurtosis	6.4162235
Mean	2744.2591
Median Absolute Deviation (MAD)	1118
Skewness	2.0855871
Sum	1.4144762 × 10⁹
Variance	5372306.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9086	4789	0.9%
9568	4256	0.8%
12158	4169	0.8%
7105	3578	0.7%
7491	3212	0.6%
6539	2958	0.6%
5945	2768	0.5%
6977	2628	0.5%
5726	2565	0.5%
4204	2551	0.5%
Other values (1132)	481957	93.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
43	12	< 0.1%
45	12	< 0.1%
49	40	< 0.1%
51	13	< 0.1%
54	13	< 0.1%
59	75	< 0.1%
60	23	< 0.1%
61	17	< 0.1%
64	31	< 0.1%
66	12	< 0.1%

Value	Count	Frequency (%)
16670	1876	0.4%
12158	4169	0.8%
10842	1118	0.2%
9568	4256	0.8%
9086	4789	0.9%
8177	1809	0.4%
7656	1576	0.3%
7586	1686	0.3%
7491	3212	0.6%
7371	1335	0.3%

positive_review
Text

Distinct	412601
Distinct (%)	80.0%
Missing	0
Missing (%)	0.0%
Memory size	3.9 MiB

Length

Max length	1960
Median length	1841
Mean length	94.625868
Min length	1

Characters and Unicode

Total characters	48773106
Distinct characters	63
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	403407 ?
Unique (%)	78.3%

Sample

1st row	Hotel was great clean friendly staff free breakfast every morning with good selection good wifi connection nice sized room with bath fridge in room Personally loved the fact that the hotel isn t in the city centre but is literally next to a train station that you can easily get to and from the airport city Would definitely stay again
2nd row	No Positive
3rd row	Nice welcoming and service
4th row	Everything including the nice upgrade The Hotel has been revamped and what a surprise Love every second of it including in room dining which was excellent
5th row	Lovely hotel v welcoming staff

Value	Count	Frequency (%)
the	515007	6.1%
and	420393	5.0%
was	236640	2.8%
staff	194472	2.3%
location	192730	2.3%
very	192630	2.3%
to	187828	2.2%
a	164868	1.9%
room	140673	1.7%
hotel	125259	1.5%
Other values (51225)	6117076	72.1%

Most occurring characters

Value	Count	Frequency (%)
	8719393	17.9%
e	4821025	9.9%
a	3495080	7.2%
o	3416437	7.0%
t	3412549	7.0%
n	2491231	5.1%
r	2426192	5.0%
i	2341102	4.8%
s	2115673	4.3%
l	2083831	4.3%
Other values (53)	13450593	27.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	38579328	79.1%
Space Separator	8719393	17.9%
Uppercase Letter	1370445	2.8%
Decimal Number	103940	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	4821025	12.5%
a	3495080	9.1%
o	3416437	8.9%
t	3412549	8.8%
n	2491231	6.5%
r	2426192	6.3%
i	2341102	6.1%
s	2115673	5.5%
l	2083831	5.4%
h	1465956	3.8%
Other values (16)	10510252	27.2%

Uppercase Letter

Value	Count	Frequency (%)
T	213590	15.6%
L	110346	8.1%
S	94440	6.9%
I	90852	6.6%
G	82496	6.0%
N	75658	5.5%
P	74987	5.5%
E	72684	5.3%
C	68538	5.0%
B	68006	5.0%
Other values (16)	418848	30.6%

Decimal Number

Value	Count	Frequency (%)
1	22480	21.6%
0	21269	20.5%
2	18460	17.8%
5	15475	14.9%
3	8777	8.4%
4	7262	7.0%
7	3183	3.1%
6	2869	2.8%
8	2306	2.2%
9	1859	1.8%

Space Separator

Value	Count	Frequency (%)
	8719393	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	39949773	81.9%
Common	8823333	18.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	4821025	12.1%
a	3495080	8.7%
o	3416437	8.6%
t	3412549	8.5%
n	2491231	6.2%
r	2426192	6.1%
i	2341102	5.9%
s	2115673	5.3%
l	2083831	5.2%
h	1465956	3.7%
Other values (42)	11880697	29.7%

Common

Value	Count	Frequency (%)
	8719393	98.8%
1	22480	0.3%
0	21269	0.2%
2	18460	0.2%
5	15475	0.2%
3	8777	0.1%
4	7262	0.1%
7	3183	< 0.1%
6	2869	< 0.1%
8	2306	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	48773106	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	8719393	17.9%
e	4821025	9.9%
a	3495080	7.2%
o	3416437	7.0%
t	3412549	7.0%
n	2491231	5.1%
r	2426192	5.0%
i	2341102	4.8%
s	2115673	4.3%
l	2083831	4.3%
Other values (53)	13450593	27.6%

review_total_positive_word_counts
Real number (ℝ)

ZEROS

Distinct	365
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.777342

Minimum	0
Maximum	395
Zeros	35924
Zeros (%)	7.0%
Negative	0
Negative (%)	0.0%
Memory size	3.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	5
median	11
Q3	22
95-th percentile	56
Maximum	395
Range	395
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	21.803204
Coefficient of variation (CV)	1.2264603
Kurtosis	32.947192
Mean	17.777342
Median Absolute Deviation (MAD)	7
Skewness	4.1908652
Sum	9162993
Variance	475.37971
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	35924	7.0%
6	26901	5.2%
5	26824	5.2%
4	24635	4.8%
7	24527	4.8%
8	23225	4.5%
3	22516	4.4%
9	21198	4.1%
2	20916	4.1%
10	19603	3.8%
Other values (355)	269162	52.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	35924	7.0%
2	20916	4.1%
3	22516	4.4%
4	24635	4.8%
5	26824	5.2%
6	26901	5.2%
7	24527	4.8%
8	23225	4.5%
9	21198	4.1%
10	19603	3.8%

Value	Count	Frequency (%)
395	1	< 0.1%
386	1	< 0.1%
384	2	< 0.1%
383	2	< 0.1%
382	1	< 0.1%
380	1	< 0.1%
378	1	< 0.1%
377	1	< 0.1%
375	2	< 0.1%
374	1	< 0.1%

total_number_of_reviews_reviewer_has_given
Real number (ℝ)

Distinct	198
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.1652151

Minimum	1
Maximum	355
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.9 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	3
Q3	8
95-th percentile	26
Maximum	355
Range	354
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	11.038742
Coefficient of variation (CV)	1.5406016
Kurtosis	51.512463
Mean	7.1652151
Median Absolute Deviation (MAD)	2
Skewness	5.0884652
Sum	3693174
Variance	121.85381
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	154561	30.0%
2	67036	13.0%
3	46818	9.1%
4	35008	6.8%
5	27614	5.4%
6	22604	4.4%
7	18606	3.6%
8	16139	3.1%
9	13532	2.6%
10	11708	2.3%
Other values (188)	101805	19.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	154561	30.0%
2	67036	13.0%
3	46818	9.1%
4	35008	6.8%
5	27614	5.4%
6	22604	4.4%
7	18606	3.6%
8	16139	3.1%
9	13532	2.6%
10	11708	2.3%

Value	Count	Frequency (%)
355	1	< 0.1%
330	1	< 0.1%
315	4	< 0.1%
297	2	< 0.1%
281	2	< 0.1%
270	2	< 0.1%
250	3	< 0.1%
239	1	< 0.1%
237	1	< 0.1%
232	1	< 0.1%

tags
Text

Distinct	55242
Distinct (%)	10.7%
Missing	0
Missing (%)	0.0%
Memory size	3.9 MiB

Length

Max length	213
Median length	178
Mean length	102.42023
Min length	11

Characters and Unicode

Total characters	52790564
Distinct characters	67
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	29900 ?
Unique (%)	5.8%

Sample

1st row	[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 2 nights ']
2nd row	[' Leisure trip ', ' Group ', ' Triple Room ', ' Stayed 1 night ']
3rd row	[' Business trip ', ' Solo traveler ', ' Twin Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']
4th row	[' Leisure trip ', ' Couple ', ' Ambassador Junior Suite ', ' Stayed 1 night ']
5th row	[' Business trip ', ' Solo traveler ', ' Classic Double or Twin Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']

Value	Count	Frequency (%)
	4710412	41.1%
stayed	515239	4.5%
trip	500422	4.4%
room	467154	4.1%
leisure	417660	3.6%
nights	321679	2.8%
a	309190	2.7%
from	307793	2.7%
mobile	307523	2.7%
device	307470	2.7%
Other values (644)	3304733	28.8%

Most occurring characters

Value	Count	Frequency (%)
	10953844	20.7%
'	4710412	8.9%
e	4062648	7.7%
i	3221374	6.1%
o	2785686	5.3%
t	2605233	4.9%
r	2079818	3.9%
,	1839775	3.5%
u	1791582	3.4%
m	1538482	2.9%
Other values (57)	17201710	32.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	30285178	57.4%
Space Separator	10953844	20.7%
Other Punctuation	6550187	12.4%
Uppercase Letter	3410924	6.5%
Decimal Number	559569	1.1%
Close Punctuation	515431	1.0%
Open Punctuation	515431	1.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	4062648	13.4%
i	3221374	10.6%
o	2785686	9.2%
t	2605233	8.6%
r	2079818	6.9%
u	1791582	5.9%
m	1538482	5.1%
l	1500151	5.0%
d	1480737	4.9%
a	1309899	4.3%
Other values (16)	7909568	26.1%

Uppercase Letter

Value	Count	Frequency (%)
S	1181372	34.6%
R	470583	13.8%
L	426560	12.5%
D	374300	11.0%
C	323000	9.5%
T	156926	4.6%
B	112897	3.3%
F	99022	2.9%
G	83812	2.5%
K	37503	1.1%
Other values (16)	144949	4.2%

Decimal Number

Value	Count	Frequency (%)
1	208250	37.2%
2	159142	28.4%
3	98358	17.6%
4	48625	8.7%
5	21373	3.8%
6	9926	1.8%
7	7452	1.3%
0	2574	0.5%
8	2542	0.5%
9	1327	0.2%

Other Punctuation

Value	Count	Frequency (%)
'	4710412	71.9%
,	1839775	28.1%

Space Separator

Value	Count	Frequency (%)
	10953844	100.0%

Close Punctuation

Value	Count	Frequency (%)
]	515431	100.0%

Open Punctuation

Value	Count	Frequency (%)
[	515431	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	33696102	63.8%
Common	19094462	36.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	4062648	12.1%
i	3221374	9.6%
o	2785686	8.3%
t	2605233	7.7%
r	2079818	6.2%
u	1791582	5.3%
m	1538482	4.6%
l	1500151	4.5%
d	1480737	4.4%
a	1309899	3.9%
Other values (42)	11320492	33.6%

Common

Value	Count	Frequency (%)
	10953844	57.4%
'	4710412	24.7%
,	1839775	9.6%
]	515431	2.7%
[	515431	2.7%
1	208250	1.1%
2	159142	0.8%
3	98358	0.5%
4	48625	0.3%
5	21373	0.1%
Other values (5)	23821	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	52790564	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	10953844	20.7%
'	4710412	8.9%
e	4062648	7.7%
i	3221374	6.1%
o	2785686	5.3%
t	2605233	4.9%
r	2079818	3.9%
,	1839775	3.5%
u	1791582	3.4%
m	1538482	2.9%
Other values (57)	17201710	32.6%

days_since_review
Text

Distinct	731
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.9 MiB

Length

Max length	7
Median length	7
Mean length	6.9839571
Min length	6

Characters and Unicode

Total characters	3599748
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	13 days
2nd row	234 day
3rd row	616 day
4th row	656 day
5th row	444 day

Value	Count	Frequency (%)
day	439723	42.7%
days	75708	7.3%
1	2584	0.3%
322	2304	0.2%
120	2284	0.2%
338	1959	0.2%
534	1939	0.2%
394	1904	0.2%
429	1859	0.2%
241	1801	0.2%
Other values (723)	498797	48.4%

Most occurring characters

Value	Count	Frequency (%)
	515431	14.3%
d	515431	14.3%
a	515431	14.3%
y	515431	14.3%
3	185648	5.2%
1	177429	4.9%
2	177273	4.9%
4	170907	4.7%
6	163439	4.5%
5	159006	4.4%
Other values (5)	504322	14.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1622001	45.1%
Decimal Number	1462316	40.6%
Space Separator	515431	14.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
3	185648	12.7%
1	177429	12.1%
2	177273	12.1%
4	170907	11.7%
6	163439	11.2%
5	159006	10.9%
7	122759	8.4%
0	103831	7.1%
8	101430	6.9%
9	100594	6.9%

Lowercase Letter

Value	Count	Frequency (%)
d	515431	31.8%
a	515431	31.8%
y	515431	31.8%
s	75708	4.7%

Space Separator

Value	Count	Frequency (%)
	515431	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1977747	54.9%
Latin	1622001	45.1%

Most frequent character per script

Common

Value	Count	Frequency (%)
	515431	26.1%
3	185648	9.4%
1	177429	9.0%
2	177273	9.0%
4	170907	8.6%
6	163439	8.3%
5	159006	8.0%
7	122759	6.2%
0	103831	5.2%
8	101430	5.1%

Latin

Value	Count	Frequency (%)
d	515431	31.8%
a	515431	31.8%
y	515431	31.8%
s	75708	4.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3599748	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	515431	14.3%
d	515431	14.3%
a	515431	14.3%
y	515431	14.3%
3	185648	5.2%
1	177429	4.9%
2	177273	4.9%
4	170907	4.7%
6	163439	4.5%
5	159006	4.4%
Other values (5)	504322	14.0%

lat
Real number (ℝ)

Distinct	1472
Distinct (%)	0.3%
Missing	3268
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%
Mean	49.442788

Minimum	41.328376
Maximum	52.400181
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.9 MiB

Quantile statistics

Minimum	41.328376
5-th percentile	41.386146
Q1	48.214277
median	51.499981
Q3	51.516288
95-th percentile	52.36813
Maximum	52.400181
Range	11.071805
Interquartile range (IQR)	3.3020117

Descriptive statistics

Standard deviation	3.4673227
Coefficient of variation (CV)	0.070127977
Kurtosis	0.65298874
Mean	49.442788
Median Absolute Deviation (MAD)	0.0577152
Skewness	-1.4035785
Sum	25322766
Variance	12.022327
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
51.5019097	4789	0.9%
51.5110993	4256	0.8%
51.5009609	4169	0.8%
51.499046	3578	0.7%
51.5108412	3212	0.6%
51.5109945	2958	0.6%
51.499981	2768	0.5%
51.5195688	2628	0.5%
51.4935083	2565	0.5%
51.5024348	2551	0.5%
Other values (1462)	478689	92.9%
(Missing)	3268	0.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
41.3283758	572	0.1%
41.368437	575	0.1%
41.3703041	229	< 0.1%
41.371308	1082	0.2%
41.3725246	120	< 0.1%
41.3727844	265	0.1%
41.3732462	797	0.2%
41.3747031	179	< 0.1%
41.3747873	158	< 0.1%
41.3750293	932	0.2%

Value	Count	Frequency (%)
52.4001813	312	0.1%
52.3924898	467	0.1%
52.3923684	143	< 0.1%
52.3872884	856	0.2%
52.3856494	1071	0.2%
52.385601	1686	0.3%
52.3846059	916	0.2%
52.3840358	108	< 0.1%
52.3793659	845	0.2%
52.3786823	594	0.1%

lng
Real number (ℝ)

Distinct	1472
Distinct (%)	0.3%
Missing	3268
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%
Mean	2.8240571

Minimum	-0.3697581
Maximum	16.429233
Zeros	0
Zeros (%)	0.0%
Negative	256225
Negative (%)	49.7%
Memory size	3.9 MiB

Quantile statistics

Minimum	-0.3697581
5-th percentile	-0.1947475
Q1	-0.143372
median	-0.0002497
Q3	4.834443
95-th percentile	16.356445
Maximum	16.429233
Range	16.798991
Interquartile range (IQR)	4.977815

Descriptive statistics

Standard deviation	4.58073
Coefficient of variation (CV)	1.6220388
Kurtosis	2.7754465
Mean	2.8240571
Median Absolute Deviation (MAD)	0.2832766
Skewness	1.8957167
Sum	1446377.6
Variance	20.983088
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.0232208	4789	0.9%
-0.1208673	4256	0.8%
-0.1165913	4169	0.8%
-0.1917073	3578	0.7%
-0.0780581	3212	0.6%
-0.1863417	2958	0.6%
-0.1928791	2768	0.5%
-0.170521	2628	0.5%
-0.1834346	2565	0.5%
-0.0002497	2551	0.5%
Other values (1462)	478689	92.9%
(Missing)	3268	0.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.3697581	413	0.1%
-0.3192925	391	0.1%
-0.306071	128	< 0.1%
-0.2915052	385	0.1%
-0.290706	680	0.1%
-0.2864945	1212	0.2%
-0.284704	1848	0.4%
-0.2835263	2227	0.4%
-0.282992	197	< 0.1%
-0.2787261	1251	0.2%

Value	Count	Frequency (%)
16.4292329	41	< 0.1%
16.4219737	224	< 0.1%
16.4217627	426	0.1%
16.4210093	361	0.1%
16.4200957	431	0.1%
16.417026	143	< 0.1%
16.4133973	191	< 0.1%
16.4129493	501	0.1%
16.4116997	92	< 0.1%
16.4082294	63	< 0.1%

sample
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.9 MiB

1	386496
0	128935

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	515431
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
1	386496	75.0%
0	128935	25.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	386496	75.0%
0	128935	25.0%

Most occurring characters

Value	Count	Frequency (%)
1	386496	75.0%
0	128935	25.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	515431	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	386496	75.0%
0	128935	25.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	515431	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	386496	75.0%
0	128935	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	515431	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	386496	75.0%
0	128935	25.0%

reviewer_score
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	38
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.2967154

Minimum	0
Maximum	10
Zeros	128935
Zeros (%)	25.0%
Negative	0
Negative (%)	0.0%
Memory size	3.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	7.9
Q3	9.6
95-th percentile	10
Maximum	10
Range	10
Interquartile range (IQR)	9.6

Descriptive statistics

Standard deviation	3.9029668
Coefficient of variation (CV)	0.61984171
Kurtosis	-1.0635127
Mean	6.2967154
Median Absolute Deviation (MAD)	1.7
Skewness	-0.78685586
Sum	3245522.3
Variance	15.23315
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
0	128935	25.0%
10	86749	16.8%
9.6	53471	10.4%
9.2	44020	8.5%
8.8	34767	6.7%
8.3	30881	6.0%
7.5	26136	5.1%
7.9	24881	4.8%
7.1	18518	3.6%
6.7	14098	2.7%
Other values (28)	52975	10.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	128935	25.0%
2.5	1628	0.3%
2.9	1207	0.2%
3	25	< 0.1%
3.1	6	< 0.1%
3.3	2058	0.4%
3.5	61	< 0.1%
3.8	3012	0.6%
4	66	< 0.1%
4.2	3822	0.7%

Value	Count	Frequency (%)
10	86749	16.8%
9.6	53471	10.4%
9.5	523	0.1%
9.4	47	< 0.1%
9.2	44020	8.5%
9	483	0.1%
8.8	34767	6.7%
8.5	379	0.1%
8.3	30881	6.0%
8.1	28	< 0.1%

Auto

Heatmap
Table

	additional_number_of_scoring	average_score	review_total_negative_word_counts	total_number_of_reviews	review_total_positive_word_counts	total_number_of_reviews_reviewer_has_given	lat	lng	reviewer_score	sample
additional_number_of_scoring	1.000	-0.128	0.049	0.859	-0.057	-0.105	0.425	-0.385	-0.027	0.000
average_score	-0.128	1.000	-0.159	-0.193	0.139	0.041	-0.086	0.180	0.200	0.000
review_total_negative_word_counts	0.049	-0.159	1.000	0.052	0.023	0.008	0.036	-0.050	-0.265	0.000
total_number_of_reviews	0.859	-0.193	0.052	1.000	-0.040	-0.039	0.151	-0.044	-0.042	0.000
review_total_positive_word_counts	-0.057	0.139	0.023	-0.040	1.000	0.047	-0.025	0.060	0.177	0.000
total_number_of_reviews_reviewer_has_given	-0.105	0.041	0.008	-0.039	0.047	1.000	-0.100	0.117	-0.014	0.003
lat	0.425	-0.086	0.036	0.151	-0.025	-0.100	1.000	-0.324	-0.015	0.000
lng	-0.385	0.180	-0.050	-0.044	0.060	0.117	-0.324	1.000	0.035	0.000
reviewer_score	-0.027	0.200	-0.265	-0.042	0.177	-0.014	-0.015	0.035	1.000	1.000
sample	0.000	0.000	0.000	0.000	0.000	0.003	0.000	0.000	1.000	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	hotel_address	additional_number_of_scoring	review_date	average_score	hotel_name	reviewer_nationality	negative_review	review_total_negative_word_counts	total_number_of_reviews	positive_review	review_total_positive_word_counts	total_number_of_reviews_reviewer_has_given	tags	days_since_review	lat	lng
0	Via Senigallia 6 20161 Milan Italy	904	7/21/2017	8.1	Hotel Da Vinci	United Kingdom	Would have appreciated a shop in the hotel that sold drinking water etc but not necessity Would recommend if like us you arrive late at night to bring drinks from plane airport as there s no shop nearby There is a minibar though if you want to pay those prices	52	16670	Hotel was great clean friendly staff free breakfast every morning with good selection good wifi connection nice sized room with bath fridge in room Personally loved the fact that the hotel isn t in the city centre but is literally next to a train station that you can easily get to and from the airport city Would definitely stay again	62	1	[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 2 nights ']	13 days	45.533137	9.171102
1	Arlandaweg 10 Westpoort 1043 EW Amsterdam Netherlands	612	12/12/2016	8.6	Urban Lodge Hotel	Belgium	No tissue paper box was present at the room	10	5018	No Positive	0	7	[' Leisure trip ', ' Group ', ' Triple Room ', ' Stayed 1 night ']	234 day	52.385649	4.834443
2	Mallorca 251 Eixample 08008 Barcelona Spain	46	11/26/2015	8.3	Alexandra Barcelona A DoubleTree by Hilton	Sweden	Pillows	3	351	Nice welcoming and service	5	15	[' Business trip ', ' Solo traveler ', ' Twin Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	616 day	41.393192	2.161520
3	Piazza Della Repubblica 17 Central Station 20124 Milan Italy	241	10/17/2015	9.1	Hotel Principe Di Savoia	United States of America	No Negative	0	1543	Everything including the nice upgrade The Hotel has been revamped and what a surprise Love every second of it including in room dining which was excellent	27	9	[' Leisure trip ', ' Couple ', ' Ambassador Junior Suite ', ' Stayed 1 night ']	656 day	45.479888	9.196298
4	Singel 303 309 Amsterdam City Center 1012 WJ Amsterdam Netherlands	834	5/16/2016	9.1	Hotel Esther a	United Kingdom	No Negative	0	4687	Lovely hotel v welcoming staff	7	2	[' Business trip ', ' Solo traveler ', ' Classic Double or Twin Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	444 day	52.370545	4.888644
5	Coram Street Camden London WC1N 1HT United Kingdom	709	8/13/2015	8.2	Holiday Inn London Bloomsbury	Ecuador	They don t have free wifi	7	2995	The location is perfect if you don t have a lot of time and you want to have a look at the city centre	26	3	[' Business trip ', ' Solo traveler ', ' Standard Double or Twin Room ', ' Stayed 1 night ']	721 day	51.524125	-0.125807
6	Empire Way Wembley Brent London HA9 8DS United Kingdom	1005	8/18/2016	8.3	Holiday Inn London Wembley	United Kingdom	Room generally a bit shabby with some lack of maintenance Some crumbs on bedroom floor these issues did not spoil our minibreak It would be nice to have vegetarian sausages available for breakfast	35	3469	Location price It did not cost much more to have breakfast included Room was a reasonable size and bed was comfortable	23	11	[' Leisure trip ', ' Couple ', ' Queen Room ', ' Stayed 1 night ']	350 day	51.559095	-0.284704
7	1 Shortlands Hammersmith and Fulham London W6 8DR United Kingdom	704	8/11/2015	8.3	Novotel London West	Netherlands	Executive rooms 9th Floor don t have a bath Their website made it look like all rooms did have one and when being at the end of a hall there s no wifi connection possible Mind that during my first two stays here I did have a perfect wifi connection	52	2443	Comphy bed upgraded to executive room with nespresso machine etc for only 24 3 nights quiet room clean 4 free waters in the fridge tho no refill and close to Hammersmith station shops and Starbucks Olympia is in walking distance too	42	38	[' Business trip ', ' Solo traveler ', ' Executive Room ', ' Stayed 3 nights ', ' Submitted from a mobile device ']	723 day	51.491959	-0.220096
8	35 Rue Caumartin 9th arr 75009 Paris France	211	6/25/2016	8.9	Hotel Saint Petersbourg Opera	Ireland	Pity about the two days of rain	8	2412	Its centrality proximity to our destination	7	1	[' Group ', ' Double or Twin Room ', ' Stayed 1 night ']	404 day	48.872174	2.328075
9	49 Gloucester Place Marble Arch Westminster Borough London W1U 8JE United Kingdom	61	9/30/2015	7.4	St George Hotel	Canada	Didn t like it at all construction was in progress stuff lied to us about vacancy	18	334	Didn t like anything about the stay if i had a chance to change or cancel it I would do it right away	25	1	[' Couple ', ' Standard Triple Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	673 day	51.518277	-0.158351

	hotel_address	additional_number_of_scoring	review_date	average_score	hotel_name	reviewer_nationality	negative_review	review_total_negative_word_counts	total_number_of_reviews	positive_review	review_total_positive_word_counts	total_number_of_reviews_reviewer_has_given	tags	days_since_review	lat	lng	sample	reviewer_score
515421	3 rue de Ponthieu 8th arr 75008 Paris France	70	12/1/2016	8.7	H tel Mathis Elys es	United States of America	No Negative	0	652	Location	2	5	[' Leisure trip ', ' Group ', ' Junior Suite ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	245 day	48.870033	2.311274	1	9.6
515422	15 Rue Boissy d Anglas 8th arr 75008 Paris France	91	12/21/2016	8.5	Sofitel Paris Le Faubourg	United Arab Emirates	No Negative	0	564	Location was perfect Room was very comfortable spacious	10	40	[' Leisure trip ', ' Solo traveler ', ' Luxury Room 1 Queensize Bed Twin bedded Room On Request ', ' Stayed 6 nights ', ' Submitted from a mobile device ']	225 day	48.868414	2.321325	1	9.2
515423	52 56 Inverness Terrace Westminster Borough London W2 3LB United Kingdom	545	10/12/2015	8.0	Shaftesbury Hyde Park International	United Kingdom	staff miserable and room very small	7	2907	Outstanding location	3	1	[' Leisure trip ', ' Couple ', ' Deluxe Double Room ', ' Stayed 1 night ']	661 day	51.512397	-0.186124	1	5.8
515424	22 Portman Square Westminster Borough London W1H 7BG United Kingdom	597	8/16/2016	7.9	Radisson Blu Portman Hotel London	United Kingdom	Room was very small so much so that I kept hitting myself on the TV that was mounted on the wall Bed was very soft and pillows were awful	30	2308	Staff were friendly and efficient	6	3	[' Leisure trip ', ' Couple ', ' Standard Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	352 day	51.516191	-0.157949	1	5.0
515425	24 Ludgate Hill City of London London EC4M 7DR United Kingdom	918	11/8/2015	8.4	Club Quarters Hotel St Paul s	Sweden	Our room was really cold and we had problem with the heater They had to bring a portable heater to fix the issue	25	4117	It is a nice and clean hotel with a good location	13	3	[' Leisure trip ', ' Group ', ' Standard Queen Room ', ' Stayed 3 nights ']	634 day	51.513930	-0.101126	1	7.9
515426	9 Knaresborough Place Kensington and Chelsea London SW5 0TP United Kingdom	107	4/19/2017	9.0	Hotel Moonlight	France	No Negative	0	617	Tr s proche du metro Earl s court	10	10	[' Leisure trip ', ' Group ', ' Club Double or Twin Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	106 day	51.494028	-0.191050	1	8.8
515427	Landstra er Hauptstra e 155 03 Landstra e 1030 Vienna Austria	272	2/13/2017	8.4	BEST WESTERN PLUS Amedia Wien	Turkey	No Negative	0	3224	The bed was so comfy I stayed with my boyfriend we had a double bed Also transportation is excellent the hotel is very very close to Old City Once you exit the hotel just turn right about 50m away there is a bus stop get off on Stubentor it is the last stop It only takes 10min Also you can take the same bus back to the hotel The bus name is 74A St Marx The hotel was very clean and the room that we accomidated in was nice and roomy	93	1	[' Leisure trip ', ' Couple ', ' Standard Double Room ', ' Stayed 4 nights ', ' Submitted from a mobile device ']	171 day	48.192379	16.399451	1	9.2
515428	29 31 Gower Street Camden London WC1E 6HG United Kingdom	457	2/7/2016	6.8	Bloomsbury Palace Hotel	Netherlands	room is really small but guess is normal in London	12	2751	great location simple check in out nice shower	9	21	[' Business trip ', ' Solo traveler ', ' Single Room ', ' Stayed 1 night ']	543 day	51.520795	-0.131084	1	8.3
515429	31 Great Cumberland Place Westminster Borough London W1H 7TA United Kingdom	365	5/21/2017	8.1	The Marble Arch London	United Arab Emirates	No Negative	0	1567	Location and very comfy bed	6	28	[' Leisure trip ', ' Solo traveler ', ' Deluxe Double Room ', ' Stayed 2 nights ']	74 days	51.515125	-0.160066	1	9.2
515430	25 Courtfield Gardens Kensington and Chelsea London SW5 0PG United Kingdom	222	8/5/2016	9.0	The Nadler Kensington	Australia	Patio outside could have been cleaned of algae to give a more uplifting atmosphere to a downstairs room	20	1209	Beds comfortable Pillows also good Homely feel although room was small Staff very pleasant and helpful thank you	20	2	[' Leisure trip ', ' Couple ', ' Bunk Bed Room ', ' Stayed 4 nights ']	363 day	51.493109	-0.190208	1	8.8

Most frequently occurring

	hotel_address	additional_number_of_scoring	review_date	average_score	hotel_name	reviewer_nationality	negative_review	review_total_negative_word_counts	total_number_of_reviews	positive_review	review_total_positive_word_counts	total_number_of_reviews_reviewer_has_given	tags	days_since_review	lat	lng	# duplicates
0	167 rue de Rome 17th arr 75017 Paris France	11	12/12/2016	6.8	Villa Eugenie	Canada	Listed above	3	165	It was a terrible stat unfriendly staff very unprofessional and dirty rooms	13	1	[' Business trip ', ' Solo traveler ', ' Standard Double or Twin Room ', ' Stayed 6 nights ', ' Submitted from a mobile device ']	234 day	48.887128	2.314205	2
1	40 Rue du Commandant Ren Mouchotte 14th arr 75014 Paris France	228	10/3/2015	7.9	H tel Concorde Montparnasse	China	The restroom can be improved	6	2515	The location is really convenience very close to the SNCF and metro Staff is professional and friendly My cousin met electricity power off situation the staff solved the problem in 5 mins	34	3	[' Leisure trip ', ' Group ', ' Classic Twin Room ', ' Stayed 5 nights ', ' Submitted from a mobile device ']	670 day	48.838108	2.318669	2
2	40 Rue du Commandant Ren Mouchotte 14th arr 75014 Paris France	228	10/6/2015	7.9	H tel Concorde Montparnasse	United Kingdom	The hotel is relatively expensive food available it is a bit of a limited menu	17	2515	Location is very convenient Hotel is of a good standard rooms are very nice	16	3	[' Leisure trip ', ' Family with older children ', ' Superior Double Room ', ' Stayed 2 nights ']	667 day	48.838108	2.318669	2
3	40 Rue du Commandant Ren Mouchotte 14th arr 75014 Paris France	228	11/10/2016	7.9	H tel Concorde Montparnasse	Ireland	Temp in the Hotel warm but room had set temp so couldn t change it	17	2515	Food excellent staff very friendly and helpful Room was large and bed comfy Had presser in room that was great for suits	24	6	[' Business trip ', ' Solo traveler ', ' Deluxe Double Room ', ' Stayed 3 nights ']	266 day	48.838108	2.318669	2
4	40 Rue du Commandant Ren Mouchotte 14th arr 75014 Paris France	228	11/17/2015	7.9	H tel Concorde Montparnasse	United Kingdom	No drinking water provided in room Breakfast was cold Assistance was slow	13	2515	Cleanliness Comfort	3	1	[' Leisure trip ', ' Couple ', ' Classic Double Room ', ' Stayed 3 nights ']	625 day	48.838108	2.318669	2
5	40 Rue du Commandant Ren Mouchotte 14th arr 75014 Paris France	228	12/24/2015	7.9	H tel Concorde Montparnasse	France	No Negative	0	2515	Good location for station and buses to CDG Airport	11	32	[' Leisure trip ', ' Couple ', ' Classic Double Room ', ' Stayed 1 night ']	588 day	48.838108	2.318669	2
6	40 Rue du Commandant Ren Mouchotte 14th arr 75014 Paris France	228	2/1/2016	7.9	H tel Concorde Montparnasse	Malta	beautiful wiew	3	2515	cleanness staff very friendly very helpful	7	2	[' Leisure trip ', ' Couple ', ' Classic Double Room ', ' Stayed 3 nights ']	549 day	48.838108	2.318669	2
7	40 Rue du Commandant Ren Mouchotte 14th arr 75014 Paris France	228	2/27/2017	7.9	H tel Concorde Montparnasse	United Kingdom	bathroom could have been cleaner was a bit too far out from major attractions	15	2515	bed was very comfortable and clean	7	1	[' Leisure trip ', ' Family with young children ', ' Classic Twin Room ', ' Stayed 3 nights ']	157 day	48.838108	2.318669	2
8	40 Rue du Commandant Ren Mouchotte 14th arr 75014 Paris France	228	3/27/2016	7.9	H tel Concorde Montparnasse	United States of America	No Negative	0	2515	clean spacious non smoking room in a good location room was quiet staff was very courteous	17	9	[' Leisure trip ', ' Solo traveler ', ' Classic Twin Room ', ' Stayed 4 nights ']	494 day	48.838108	2.318669	2
9	40 Rue du Commandant Ren Mouchotte 14th arr 75014 Paris France	228	3/29/2016	7.9	H tel Concorde Montparnasse	Germany	Refrigerator	2	2515	Tea machine and hair dryer	6	8	[' Leisure trip ', ' Couple ', ' Classic Double Room ', ' Stayed 4 nights ', ' Submitted from a mobile device ']	492 day	48.838108	2.318669	2

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Close Punctuation